﻿CREATE TABLE [enq].[Instrument]
(
	[Id] INT NOT NULL,
	[Type] INT NOT NULL, 
	[Name] VARCHAR (255) NOT NULL,
	[Symbol] VARCHAR(255) NOT NULL, 
	[Isin] VARCHAR(255) NOT NULL, 
	[DefaultCurrency] CHAR (3) NULL
	
    CONSTRAINT [PK_Instrument] PRIMARY KEY CLUSTERED ([Id] ASC)
)
GO

--Indexes:
CREATE NONCLUSTERED INDEX [UX_Instrument_Isin]
    ON [enq].[Instrument]([Isin]);
GO
